SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569156 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569156 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41654,440717,390741,1024888,159306,1035100,367223,454565,784559,714764,132219,312162,178618,828565,550853,62561,314725,582022,887940,382440,319139,968768,63497,1013909,998740,169941,252659,855727,532919,510326,909272,668250,329400,330923,226743,306766,26967,246794,938265,238128,1038121,717491,680924,499182,272955,295099,835791,126179,1030313,737630,120648,679618,790214,365599,1006612,963612,576683,449133,643833,642275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]