SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503990 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503990 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007069,78099,354080,431917,626264,176977,448483,368049,573477,585458,323792,624006,947538,915133,395855,631772,108346,503436,839436,159442,10843,185841,691114,768032,790827,1017313,161030,1033274,370007,1011069,734615,374590,1042378,142301,324381,431299,249038,310039,886945,849940,203058,497635,697095,36657,45773,54093,287840,664906,1020242,108202,548688,824363,169839,288355,677341,71433,342230,678380,479502,298922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]