SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002973s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43048 LIMIT 1 [ RunTime:0.002978s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43048 [ RunTime:0.006650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283672,311193,1020574,359490,258795,354356,651538,157479,441243,911867,393144,595269,803749,348806,624283,1010546,40202,923510,823745,27434,104075,1013606,873016,433866,217998,385462,348099,488230,525781,126638,74164,577550,1044569,284506,473431,96443,333162,471736,140169,399144,32580,1038176,270230,1010947,437617,80158,1000863,873621,741607,585231,643388,128621,766318,471723,343185,603946,63625,673985,404843,550438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]