SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467084 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467084 [ RunTime:0.003575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533329,1025858,661266,309094,959347,284701,720203,929547,320366,243955,669285,494911,64362,168646,899327,158830,990830,348143,165333,401944,699020,663881,1047382,804043,194517,757292,695774,312406,654166,222583,193905,380240,751568,23120,447674,95254,900707,127806,759504,739063,353325,489311,999540,915571,568136,321157,891589,616516,327425,444337,811985,474830,104238,574610,247810,46049,223581,521326,343917,155001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002400s ]