SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841978 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841978 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038400,465532,1023343,830746,110480,887551,412028,3148,784091,979225,290194,29269,853368,376058,490158,715024,506818,195835,29053,742002,968668,342158,679453,847079,817875,963445,494903,793599,382879,734580,341082,877433,895112,729954,191362,933583,958595,200038,763480,103287,525084,751306,375127,687953,219624,321507,732313,839368,448888,706004,962769,231603,814781,748428,82701,803609,808748,468117,851683,394898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]