SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 902018 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 902018 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642229,908681,713102,149101,47098,935954,851287,327135,462268,254904,2442,1044650,771895,696378,998382,325489,423662,168151,937500,528699,77430,893415,566906,127674,1032944,760502,956032,1047485,601675,20702,588711,909547,397999,175081,259908,386640,491692,593296,767568,694195,428204,859131,957878,531822,290851,869689,829628,979815,926108,534382,715056,737727,696485,365880,627941,793963,887026,430362,972442,389424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 902018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 902018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]