SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020273 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020273 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205485,841840,15185,130471,992213,589872,317946,374658,999152,510861,75409,225193,1001450,772873,357783,1027471,700502,596358,351970,199347,1017812,752640,412594,922273,572727,357333,730695,370741,498434,109021,236510,455151,345750,368500,299658,843611,606455,332965,98394,43483,806128,160032,19314,709081,126708,703157,464464,814941,199491,738101,108042,875506,851278,458524,592860,304673,105351,704302,620581,244748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]