SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478841 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478841 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336488,454837,505628,912691,810416,248374,950400,636054,381074,611283,127268,843579,883603,546141,157774,198900,424693,753186,815574,653953,407782,132915,882441,385518,477664,976397,75139,867408,664945,447657,44868,771300,1591,852397,63801,359770,1032264,573581,495433,708713,956695,353269,154163,594285,606148,835338,877792,525709,144826,464845,285429,21290,227683,597047,856731,546273,751322,831426,128869,226655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]