SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516153 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516153 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371268,155033,254202,364365,922011,1012374,773850,790271,850932,138238,927290,152363,278121,348581,282035,402360,890593,766495,1032573,399593,622342,479926,276356,329083,283681,792159,31996,405607,279709,21233,763546,230277,149129,390400,366241,122146,645169,616964,815077,622677,741066,5286,158427,8857,596721,205123,685090,171363,121622,255433,874814,501218,991500,801395,1022798,823750,303193,1041353,233074,738923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]