SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531228 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531228 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425693,140282,81315,648172,511329,1048191,501934,713550,553848,380120,831277,7523,663075,843960,569427,437923,836613,923484,777630,111468,39247,365583,666146,1032962,930875,353040,473822,655843,236403,425726,155314,886714,277871,682075,745254,685914,869167,680536,54650,430868,945269,87672,778568,446354,846029,460384,739649,782042,264472,700800,315222,419300,568170,792793,348239,264766,263443,291974,709141,253831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]