SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448319 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448319 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652831,202289,386035,775933,417003,780735,739706,589394,108616,772684,256641,301182,552414,23699,434026,929209,703264,290208,1001895,149027,996675,905599,479745,654078,774396,56714,324818,521105,274917,931819,39130,468608,150551,936635,977457,512543,155045,731442,178021,789788,568340,775419,121631,937795,673949,644847,81776,608621,558979,333573,29326,728907,492738,1021849,22724,966202,461963,859866,813374,221822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]