SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403770 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403770 [ RunTime:0.001442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351087,73761,875340,822824,417391,228347,645547,51946,725049,14384,123521,333049,795210,686633,1040241,289329,466230,101055,584629,512035,97081,876355,765446,1014532,415666,400105,859027,534198,894440,232642,414413,996953,1027284,113269,795251,145922,29576,421441,443308,446514,1025623,587348,439165,449728,494344,374342,756733,284936,492972,249612,72231,41405,415090,601788,366412,810211,435132,859909,785683,604239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]