SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011124 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011124 [ RunTime:0.006478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261831,517343,195516,106210,261166,469460,808349,610872,235257,295772,739860,200542,892256,817704,18661,499814,145258,653393,721143,729335,921881,832550,703828,357588,18393,606365,305907,26609,858303,693991,831428,547783,893112,666890,283175,1034378,271,216552,164975,361361,716594,366783,802671,620219,704142,84704,450202,46204,256977,203822,17045,384278,22804,822255,247128,977733,199740,244294,75146,399892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]