SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441234 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441234 [ RunTime:0.002820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888056,660343,183841,261852,668153,1030166,223138,1003513,758372,975046,50277,868613,740785,131420,231053,117672,783724,318528,1010466,439678,153929,845851,565536,353067,288036,867239,488126,496398,809818,670548,796608,909916,40153,673652,445406,496233,408705,733780,264791,551134,219855,394083,489029,293010,513656,131226,132289,759731,466145,120152,135752,229835,425359,697009,829319,714229,268208,273954,326283,572602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]