SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549194 LIMIT 1 [ RunTime:0.002961s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549194 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281538,50981,248945,634242,177430,77262,880015,493841,658236,973930,648642,627644,147978,297387,1016234,618506,838468,586970,411763,9658,863007,680489,20042,464697,964110,934526,631800,133363,655081,80509,851095,250792,203174,223134,30248,313600,302634,248526,865986,1035036,929804,390875,827636,533517,626117,960285,655260,153679,691996,22542,358381,253657,952032,622626,83033,1034514,347243,955752,898926,594979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]