SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414070 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414070 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689034,1043500,409287,332499,412231,821338,731396,250469,997525,632344,79427,604483,250051,326256,496408,875807,508443,808862,899906,871627,476224,920265,819425,837342,158614,561539,1001323,425735,601235,235113,587573,259526,660996,551457,604697,259589,379605,234641,771571,381116,68775,128953,30054,784339,868387,642684,810450,531848,750066,110739,459680,917319,217428,150587,229200,916740,100885,172565,749929,802049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]