SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58311 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58311 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752747,545410,1862,584344,338979,368104,625413,280801,929457,1022623,252763,521992,2983,498649,473925,212539,284042,646750,815385,109429,1007169,667711,887599,115771,636376,235585,546094,579990,891349,543489,887607,530882,689408,812438,513003,29820,969400,575495,886617,897303,850530,847789,256607,350631,281181,584081,370758,427262,562376,958539,895298,532315,743579,36147,489478,134006,509251,109134,258703,913256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]