SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003764s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503501 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503501 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31032,683350,391105,397767,829503,209279,443689,723027,1014719,509855,175342,154671,83060,939236,290145,857951,1044318,419674,949428,375514,197514,585394,507595,121263,731381,422437,2290,633728,944806,590289,348737,180282,695948,920071,908493,935286,771907,989378,570485,206683,460118,485937,242571,869916,403180,773546,987359,866878,974657,94438,200605,135813,814868,927150,319259,587657,225279,283853,906801,874829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]