SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011759 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011759 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511048,812828,114673,550260,821103,302133,756816,340224,726355,357078,953338,44179,805637,169679,539001,194048,1046102,411209,137480,227439,434052,854378,810189,87013,87750,741666,873727,652467,687071,174648,190132,325609,203927,1041397,536013,431766,564373,475612,80308,482108,255506,847521,588833,229284,273687,152663,690713,291450,612000,891609,445920,554964,831102,891330,28830,601634,910527,925913,608182,253061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011759 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011759 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]