SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268622 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268622 [ RunTime:0.002608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318516,646870,42094,743931,1028837,435356,819128,47806,342493,252762,1004915,307458,566042,575806,623280,584973,745733,910146,1019558,154545,754736,841306,24141,615016,115982,966798,253213,720974,971325,178820,920346,411298,461314,451393,68315,420912,87236,57118,500651,178764,684855,48316,668452,870357,870128,568865,388058,210490,493945,626218,332104,480925,694873,858436,923034,252990,194340,511496,303943,806033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]