SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681807 LIMIT 1 [ RunTime:0.000785s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681807 [ RunTime:0.003599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98160,566588,898399,349287,204843,105803,596996,89503,116171,367761,954468,35799,51381,891621,902836,615931,476798,1043774,420009,1024363,333031,413395,517532,595636,600116,303600,570768,867489,657000,485383,407436,710795,128879,184956,703332,301607,300053,117351,167008,773454,392345,52807,170914,1005939,1044055,707585,94860,866571,49782,880317,840613,542492,51683,771252,1005837,721968,251429,462551,960899,62082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]