SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039254 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039254 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535710,821432,34729,534445,152467,535382,136399,1016313,880915,37861,65381,893528,45476,356722,71369,671580,651077,267295,181114,76857,537465,70101,608990,220737,186803,269681,190111,861035,226039,96989,325214,794392,1021851,336019,430,55584,585769,764650,444609,675149,865775,447696,522277,493681,828387,216086,745849,449626,678390,960010,110204,611617,504992,946367,212359,30717,969239,306843,552212,794972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]