SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012378 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012378 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434565,422473,64825,710379,218656,549108,663140,1011370,643593,864554,871071,1036777,658249,405298,732982,455762,1001348,625175,986993,477930,735915,472474,353226,494164,949429,349891,67594,1016911,460909,373260,186831,70129,908670,920742,943465,990605,734483,289723,214330,237318,782103,959955,176106,107406,449249,853600,373281,662197,397164,426955,35932,944909,813371,304248,92275,463131,548217,877071,721207,182325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]