SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428027 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428027 [ RunTime:0.003070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962413,488118,777177,374891,253361,15890,81967,155707,389907,804094,743120,293727,641958,662330,528000,402177,611127,357176,732990,366059,828678,970527,454483,848551,989622,929097,843553,945539,21450,704481,885196,124911,951534,941463,144718,976286,316898,989853,278300,643480,838547,309539,692297,295666,529219,108562,665652,180335,95818,353734,226329,638373,929144,20726,641032,587706,848826,701629,742410,248255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]