SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405148 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405148 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912100,786233,399386,792217,451202,585776,3919,641028,628464,792438,865969,170624,966964,181225,567094,1026752,408844,47392,99140,324272,354248,532571,266204,650742,157570,875346,277755,805440,201639,998797,378449,544654,678898,25466,856213,981242,948336,79738,1040173,782884,691414,740968,583149,1033464,593931,888018,677662,804050,645030,729164,280106,932984,306845,886845,908397,344866,47043,383750,824161,790168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]