SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019894 LIMIT 1 [ RunTime:0.001112s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019894 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563263,371399,765416,757756,793421,585831,47862,717467,976770,1036893,277541,230660,906382,861087,618023,730274,6382,637603,530813,60415,486196,756482,488411,445505,821573,546068,831387,259730,234655,278473,73551,172828,802248,103466,863775,745346,323442,635743,858243,653039,177036,890202,921040,995499,435423,792167,900692,761106,105685,62090,449606,143298,824893,763209,233952,506138,77210,535384,290102,896139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]