SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101576 LIMIT 1 [ RunTime:0.001149s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101576 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453709,89145,220150,685300,108180,1013523,64056,903524,951914,770305,926402,906974,420383,495386,601379,369023,227860,1003920,195163,679724,868916,830383,116984,264343,479266,155149,983110,784420,321946,923977,749647,488104,842468,785721,94409,142839,760095,561639,932127,184278,178013,466152,1014575,1028947,32480,287541,903740,714167,372204,61451,1015580,978024,274457,846916,963349,789474,850047,190808,505888,309602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]