SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416824 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416824 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789684,687757,977684,68633,301212,233819,22115,691075,606609,930540,502862,743330,142098,50060,153197,120724,244166,792574,467083,195159,923588,38720,483062,31541,647075,157623,982676,845757,113975,298894,1036828,917215,980657,1034888,321040,654553,432990,973273,276442,742970,675085,261068,770862,818888,728848,300755,312112,741036,101381,276491,355172,294674,174748,274866,109856,210700,731629,755616,1020523,59999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416824 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416824 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]