SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001856s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503445 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503445 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454064,721748,977968,140697,168974,816253,1034399,307387,286670,704087,41241,394662,580410,980404,282692,841037,343337,970928,314321,413521,985994,936167,614117,206718,55556,929273,231738,1030623,93646,137844,889065,554818,533984,180835,769722,48942,365054,351524,550321,285100,80752,133351,605731,743716,682078,336306,227859,34509,425729,109143,776415,481264,454722,922523,340843,186349,1018367,194054,895797,285579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]