SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023219 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023219 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18701,139820,852463,934866,492302,806007,700703,655105,11298,1000996,457037,644552,232961,187200,1018862,1619,899771,653589,98897,270896,338080,614021,334985,153664,773810,412744,1024517,935855,816289,6766,579035,249186,37032,691241,224775,671823,486186,927845,324886,805471,899812,632064,147262,449739,1006820,410283,122567,653839,360507,392824,566572,941485,81927,634887,592199,108048,560177,971376,509746,69925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001071s ]