SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490017 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490017 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393393,400391,157767,141790,760642,130247,945749,899899,644291,668432,420153,190617,237430,1024427,185463,493590,971362,149710,507217,370858,134871,989820,494709,701227,410019,491523,836571,820801,919954,67865,692582,357364,334104,615963,751099,836597,956248,1033053,760766,139846,176564,932391,578714,653259,543788,793969,617859,569948,185225,554708,879590,754747,632180,334404,234811,155013,7660,480421,1035375,33715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]