SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566292 LIMIT 1 [ RunTime:0.001321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566292 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982107,917871,434856,586151,891299,112390,276962,489138,446784,790553,515247,778306,166319,136395,548155,337140,751291,952942,500776,283965,379448,885206,1017050,821825,237175,471471,381996,767816,444570,467004,868696,66426,270065,128811,987231,28882,403057,761750,228209,308130,324792,625177,517137,453833,301053,289931,806327,993848,337098,414719,323736,888903,526736,568927,825338,986901,31434,98021,709978,1017572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000949s ]