SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484899 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484899 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154305,476269,393052,725950,378944,441137,423961,686299,1012922,398869,875762,275137,990435,653850,527796,465294,118769,871118,615811,104990,403953,760226,258540,532804,292183,703541,855838,610725,385917,186706,1012163,277545,406851,431365,658576,418276,87660,910321,297814,291443,399190,872731,987219,794506,55421,248826,548689,449060,143478,810656,186685,362117,445852,163186,971817,841749,573479,230575,530771,539834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001830s ]