SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416082 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416082 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166478,751281,609670,1002901,7933,302890,368670,610888,755786,146507,858004,283981,555352,913356,226926,249430,809347,837172,857277,499088,907724,1037933,161738,804974,706031,615713,662676,693842,541093,988870,469787,875966,659513,680323,519442,821052,1011317,682390,262382,389076,94803,250551,471422,525035,636172,707657,607642,872812,994670,722844,409978,384736,982637,648641,180517,274498,552365,257630,93573,764016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]