SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28133 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28133 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614248,910617,470923,854744,802799,624142,257304,418113,710618,527692,675854,649174,650953,469260,1034043,780039,507282,78809,141863,3516,898586,344192,241014,574244,125057,217736,317111,132899,18654,589908,737107,210087,931433,495941,842864,898505,460141,461248,682,414179,419230,369476,501160,474988,409143,164112,944266,546594,881370,529139,716854,458228,732304,188360,574417,553146,731357,793401,829065,807115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]