SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423901 LIMIT 1 [ RunTime:0.000599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423901 [ RunTime:0.003217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035878,674812,195737,711735,776597,1025701,65744,723217,152413,463376,933860,482884,365521,358055,250244,501398,54443,852295,380177,19303,929179,470704,570244,398142,303781,899143,614481,978475,533111,418574,790597,196504,402345,519635,951378,33183,743055,1015317,242914,523472,588099,974944,481475,851608,479102,25291,973224,462341,901076,398622,860133,530471,333734,998118,518557,631105,393883,147398,818739,807056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]