SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310811 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310811 [ RunTime:0.004462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434049,947381,785463,10420,502311,444614,846296,123746,147289,649176,808442,259950,919516,864262,10223,801635,1028619,411673,12168,307910,701341,340505,365035,793215,998870,624052,813068,501720,174096,718292,706007,743020,186520,1021938,811139,644871,462876,482873,518892,784531,946657,359087,911233,570946,717094,381613,872027,975578,206531,313028,406629,10780,88761,667081,862748,968498,895977,3919,791933,750382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002789s ]