SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527323 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527323 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866627,620374,743654,456596,639130,908401,97438,410530,579502,1044698,815036,704827,544940,631299,282274,87781,198075,544737,382703,68964,438322,343948,682978,531024,1037094,1046488,345219,44856,559168,710065,535049,378443,626552,765353,529066,1002032,135527,402264,659051,834948,767892,284150,641755,222434,910549,448680,268448,583296,891980,942034,256809,840958,225150,783516,756874,20771,453197,265720,313129,843561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]