SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419514 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419514 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841032,650205,689280,579042,517664,109513,246413,295074,948511,39551,1037593,934152,822275,368538,945833,409913,692440,919409,979697,676836,590060,708361,37659,592422,297751,117826,874844,266697,602307,831408,2430,14696,1007588,441111,668757,364174,156688,584231,48715,929777,151498,867301,421794,456684,599480,770525,60970,976860,690833,999365,578052,610001,66727,544073,545994,1009912,647912,509819,321240,17423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]