SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 76318 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 76318 [ RunTime:0.002439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449168,573549,78500,429700,850920,196287,981121,89773,396250,35305,898160,402783,710878,321067,986287,183589,482021,285110,67009,140001,233550,781952,220406,462924,569345,375588,113012,169646,745558,561497,310647,104184,175116,565826,954037,195286,485801,972737,319923,333919,833314,76920,647765,588632,240623,660805,311525,565422,169380,639192,45638,173503,796562,854968,928777,357442,943282,919355,31656,63975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 76318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 76318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]