SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510490 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510490 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320399,499131,1022621,951081,708166,622672,164848,236509,27454,90578,1031152,800822,994388,688928,797175,211424,381877,622069,747464,65806,727989,696293,972630,414140,637640,336854,395938,570153,894203,678982,781201,659706,60473,1040215,474907,491269,926560,670856,893175,801245,1036038,376226,5709,903818,341433,494277,328041,730178,723509,716693,849566,694645,947595,11816,479070,531246,371270,466328,986273,594640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.023835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]