SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003816s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549610 LIMIT 1 [ RunTime:0.003687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549610 [ RunTime:0.008840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595508,284335,813829,389596,366528,161725,811466,437556,819250,22955,801956,486412,454836,147620,644984,755830,356565,607712,348693,861694,280093,87585,445578,45853,713665,591678,177563,55032,969524,772184,512229,102805,189850,56581,910673,569191,500429,79438,316481,486407,184723,664966,842697,1018284,18630,321953,438029,262041,1023582,150282,343151,130922,337430,386156,886408,295057,872175,430316,297416,201051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]