SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 151028 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 151028 [ RunTime:0.003229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890284,795490,453475,780918,1004803,380263,458849,1016026,45016,324432,316838,88328,835748,557941,976535,948639,146145,23224,879680,1014915,517064,637169,559727,1034515,198095,721524,553997,757802,623019,471514,300983,275004,403666,19585,425831,187281,224903,437659,425377,740073,892662,187419,42384,977060,573543,199669,824973,85131,730716,612148,974421,142963,611553,971665,291733,548742,678919,270267,51630,1018997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 151028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 151028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]