SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023486 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023486 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668939,453788,209908,301174,495108,366386,192752,506316,21882,376272,1029212,1020685,987229,626039,217867,714371,522164,360370,90190,867915,942628,466600,785091,24179,636388,476143,84749,979486,251015,155017,192419,244338,1040494,930990,724212,166260,787705,243426,126001,500127,665856,216477,272781,443353,842355,79559,480698,170467,145739,54815,715819,109429,443110,955414,252761,283191,252699,451509,269048,766378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]