SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529721 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529721 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021167,335635,727928,420347,643355,1001465,157813,151431,287293,25561,956173,30102,421913,627645,270477,529666,1008641,255865,803144,308576,814638,954274,504112,579261,332451,680946,335263,260781,255501,1019513,103838,90991,581624,289893,844851,629680,1030628,532126,365535,66524,6693,653827,718683,859251,965041,248981,94145,321440,17578,558581,491801,459388,235863,708978,784535,988084,818087,76041,357971,717161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]