SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007582 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007582 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34281,112625,444429,81666,999539,1017699,415282,990234,195664,1030716,807109,739867,161594,919419,538716,69464,153415,686492,1048468,30634,590414,21929,294944,143109,873357,526570,78518,729678,760413,461689,407510,894887,16496,399409,664455,485536,858055,895901,979440,130064,237673,562396,563171,416429,102769,418033,734135,529267,965134,887614,427179,1026090,609802,1036026,648606,103319,827746,569057,264237,685055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]