SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483751 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483751 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569019,690916,499175,653587,889570,282812,683578,241164,351399,530288,766122,32418,879850,952041,40027,791895,459316,287303,697112,798121,264111,254284,793664,126171,547945,1026421,454285,363828,474008,862894,1018723,15972,758897,176555,52583,580189,162276,815644,675056,398496,623214,309189,647681,691786,406291,655728,524592,518930,513708,202678,65378,357793,347568,555301,763656,415217,856205,795350,875508,141492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001942s ]