SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494505 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494505 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032889,496503,124736,678640,23340,781084,809700,88054,963415,157102,211745,242173,671581,384499,911329,849973,672223,528819,884122,115288,888210,703215,15748,1030496,856961,804892,578223,89273,970250,1031477,382990,122646,826845,840434,596191,981281,284898,843784,464446,195072,1018048,681313,32703,749749,368012,833561,514111,156918,298512,609087,72126,641423,1045057,723236,588604,954610,759573,83299,411265,82020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005220s ]