SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020546 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020546 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890790,310326,670578,358227,493648,862298,201205,20094,422334,423645,405534,804563,353232,920071,487461,355067,310296,680124,775622,525092,125498,137804,159109,578227,136400,806548,948657,945166,548406,204493,138668,592859,825649,548385,610406,947435,964539,879957,472594,765625,570064,408055,447680,35962,942540,729468,16899,953671,176602,905550,26287,170972,697481,48547,953790,293692,532388,385016,275973,639043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]