SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407187 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407187 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852623,930379,917593,989654,921049,669255,1026360,810103,888060,1010611,1005163,418831,152914,478906,82448,441837,1035674,351011,455893,777484,200314,612531,284695,742047,660264,458181,539823,755644,609151,311288,555848,941950,267532,673380,173098,70690,657511,155795,334828,712368,756167,137599,118388,573652,181532,818385,221102,757276,166846,203416,451675,128966,613999,109689,876181,365143,828211,839361,368636,289981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]