SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46680 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46680 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368461,144288,275306,105618,565743,353468,866376,966291,86120,993955,227454,28754,1014710,285076,425383,1045070,639022,843397,749,959617,157980,627256,247182,556891,728461,264150,468030,29308,1025926,925607,941923,415248,499283,775546,601124,562079,89144,854952,411732,244639,1035441,924708,486824,657122,92215,362426,104133,191328,546083,914515,703006,851965,528890,730569,526769,1003168,836513,933284,167008,118456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001121s ]