SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558908 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558908 [ RunTime:0.002855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388097,742776,350537,768672,235237,664046,618560,543931,724251,716033,918032,320047,668496,69099,176125,389041,633034,19979,252753,875054,603857,199751,222044,137058,9083,717233,466623,736925,572436,252243,380568,573921,599042,1031738,840261,686956,710245,310133,402640,275453,894908,400918,883167,204168,861749,152042,130676,728918,824123,662258,314834,736444,567902,247036,987817,28900,755094,206185,430933,1044847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]