SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031243 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031243 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423453,551965,640551,1002729,478550,406929,883120,268528,205224,420061,465555,149678,842629,440582,180637,560242,513782,979192,1035145,514085,395156,14929,743748,712219,334144,854594,574682,658703,184470,349775,932201,632918,366568,443016,73537,799065,582171,1043744,680614,301686,583008,354039,677769,648248,426534,695380,840764,126166,498283,895970,18495,565314,814867,76224,523527,659466,572467,702249,893936,644567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]