SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485875 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485875 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406075,1037879,369294,646323,261409,807325,931116,960785,1006845,447461,631695,984261,58527,73282,524961,363643,648770,988308,382489,1025299,862542,501643,508301,648191,454910,255222,726294,504802,48936,914393,29482,876572,890841,777883,10257,419982,996871,1005128,969495,44667,835979,699297,174381,794273,131778,545210,865869,82006,842358,998673,974771,401284,604031,216528,174082,804011,26400,14178,771257,1005071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]