SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261200 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261200 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608003,1034056,689398,975381,203603,811867,112297,632778,899601,389866,1047830,328135,690626,193230,810977,640467,98004,5574,625117,86396,189253,374058,354121,483060,324625,516843,127531,941044,819685,587687,430909,729170,549352,295729,894858,906631,460319,393382,874348,28415,468329,608093,377448,848250,461957,245970,577779,745678,929878,902928,364771,946339,604396,1001585,439054,391865,205744,180781,960092,799541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]