SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445712 LIMIT 1 [ RunTime:0.002243s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445712 [ RunTime:0.010078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440342,691514,43543,805231,676182,659388,1022665,891339,801014,800976,458484,776596,910392,306106,318839,400914,227640,743880,195862,804861,106064,120650,764288,9719,651005,585291,206307,56947,90831,437954,431017,869430,966892,608713,580880,636189,359309,488286,845721,715097,727633,918918,1032873,293473,676509,556690,80248,931829,866342,964879,44021,731038,735538,191410,119212,77689,149757,780489,221617,64558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001197s ]