SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335804 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335804 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576422,214582,1006673,262508,887163,331122,59755,239355,836832,47278,453472,769003,903291,706277,498517,254296,741095,112183,612880,410611,50310,55026,390818,831387,576288,3466,690215,258714,1019676,847547,670305,249176,365100,405275,376373,568488,102208,218384,342403,164820,455429,199117,103407,197560,47595,239820,934030,855698,849624,136634,41050,916461,75488,341071,280156,418300,975625,16908,534206,164246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]