SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502873 LIMIT 1 [ RunTime:0.002392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502873 [ RunTime:0.002381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500441,246440,920671,567204,114378,466865,647973,597362,342646,124892,453542,815894,428469,439455,620877,463724,860997,1022837,725655,1003441,893458,852763,490753,936575,803507,582532,7695,983779,830373,1041926,256679,147010,545544,419256,826261,913151,444468,839237,184490,887387,735611,720925,607491,770037,794481,394792,611942,870655,147639,338339,831797,986369,340792,689018,363176,1013139,681566,937702,301020,691685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]