SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013966 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013966 [ RunTime:0.004117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47649,127500,874974,603571,68577,692333,379927,286613,13514,630300,761195,787607,272490,653534,364591,398293,712845,813544,505359,172083,308228,799415,180534,136945,165275,46741,587012,613094,244242,960715,933520,359654,608180,828979,865464,28116,240620,951425,917881,170250,858245,713883,216140,386702,592818,508160,691926,461719,280425,956574,251858,472426,860063,362731,199970,966404,351292,1010934,533065,806282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]