SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104291 LIMIT 1 [ RunTime:0.000630s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104291 [ RunTime:0.003624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772234,517762,178658,157846,282024,914586,1019432,41946,293305,705954,322342,14671,17294,703151,304558,790172,285789,777416,717605,566449,447331,172103,270831,922988,17249,354078,965576,713537,499905,344458,132143,1015551,572770,169516,184766,7083,14260,61952,647652,595736,141881,926406,749445,251905,830324,775757,66862,325962,729815,372817,497345,313198,491142,263439,859527,340966,807140,820082,831057,140716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]