SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006010 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006010 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646149,964351,646668,228398,931006,160397,612360,438221,955431,410196,836211,20050,18026,150728,222131,965174,616811,989581,1008396,884091,795379,928044,389476,203443,858575,270227,6055,330311,137675,345802,676708,823788,274651,145879,164109,509150,233046,916593,897360,434642,293933,656286,965342,291208,14895,1026008,1012800,536905,437291,227656,757726,317029,829585,59551,830670,543271,874242,198070,931055,666901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]