SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523458 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523458 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927080,64615,1020985,554445,659963,752636,262947,1012441,457399,964144,294636,39591,591566,406792,51584,1034163,36997,847904,861845,868193,1048128,794820,151843,764516,26315,103958,444607,113663,606883,263084,17019,257767,510448,149794,595839,260478,1041588,457235,239657,212931,358516,1020314,63602,703015,1025417,459876,836810,532784,22634,43562,365055,588246,766956,390871,568410,232926,748282,802197,479105,355281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]