SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543936 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543936 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468529,977043,936025,630275,890820,838709,351289,569095,826448,1029515,381293,256205,565084,75609,157205,1024426,602371,808901,201729,897846,220548,744447,677584,440142,815695,842407,893493,947497,661593,556405,522272,291805,187513,881176,479011,346984,744744,551148,564887,64352,6792,834777,754462,892765,754650,934643,292502,422099,467378,573464,411639,655565,735105,809151,312099,968829,948318,881363,396938,753031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]