SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444876 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444876 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138954,403607,920142,255441,545157,221991,141325,630372,768681,336393,490527,138731,1027059,161153,701312,448699,968967,695509,89910,1011817,634217,172108,140751,33720,1011714,783971,103880,286288,479230,409845,194504,683230,483183,1015884,912955,124599,921405,816829,720799,412728,501227,798641,489501,194195,509659,1025311,926026,4949,603069,919627,1010388,774450,248121,720285,818809,627917,792950,510125,894970,643338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]