SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508550 LIMIT 1 [ RunTime:0.001006s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508550 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484680,75497,709234,224980,727932,334584,973241,108145,844934,857746,970334,202509,295311,637117,508925,167136,478279,654944,868016,751142,1038056,42058,380910,310678,805705,509046,993148,611975,403939,104667,26276,828590,167069,536248,631590,244603,482024,376659,745178,284009,762499,675050,217600,895484,708590,976526,565067,56030,1025960,572089,619048,24004,15112,77614,691868,401827,366413,349001,139567,397239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]