SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013437 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013437 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789405,964098,483302,279760,423329,244339,824019,450142,926434,393028,209336,295076,921872,432545,510282,33389,931279,696084,616189,412972,208326,258689,794041,969555,308034,1048030,769590,594502,664751,551940,401904,575719,706327,8979,185502,689980,628048,102604,895498,44110,453557,163200,174457,35792,457060,395439,524957,1015316,163060,802835,491195,735199,841642,873479,748586,683913,960244,472317,706921,717713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]