SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389512 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389512 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351046,412109,497086,942859,250119,379193,204003,383443,278218,380047,340026,632871,1041104,545288,719129,973520,106722,184448,433861,993116,560083,849884,235520,508494,784371,125459,359559,308492,68101,214753,1025746,387215,731421,9536,495945,835683,673008,851414,210505,942495,1701,65713,169195,1037253,489199,714839,468706,535164,43042,1014927,625979,419115,114232,612438,102712,474840,252099,684290,377157,578553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]