SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48271 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48271 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16607,856720,598565,506755,270138,438302,825736,636974,183195,505245,527952,516057,551040,754568,481340,314274,187038,813528,1000265,693684,851275,473188,730808,220243,502497,608227,1008042,24483,802347,595869,481153,126974,246004,138289,196634,138936,999467,1032071,1015358,716830,54244,540798,419223,426344,520905,568201,808952,611682,145791,848487,376300,397005,709785,399616,206021,906815,649758,660691,893965,811706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]