SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392346 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392346 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436346,533174,953610,197898,301522,12900,589444,261988,527395,928885,600650,222241,706668,519269,787693,594908,461854,487975,10324,282126,245493,917876,819896,314286,388585,120461,942017,313242,608964,588192,351664,911078,103610,97067,55271,693209,455040,618798,727156,664724,527901,802668,951494,24184,709244,35352,70063,141298,256796,72853,743662,872037,315051,1020451,27788,1004802,686172,730776,273037,270957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]