SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570212 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570212 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124945,435272,274110,835558,937862,228147,558015,430710,758934,420376,142115,378171,195991,735666,799867,308801,408612,519570,744363,185028,903303,940130,655432,766087,238072,27240,153273,898353,568756,920289,548166,589369,3544,555746,704785,695934,480574,337837,623044,216470,792184,930830,610091,162591,377656,659688,833599,1015485,990201,840696,447347,46546,1016742,327754,825573,437526,297307,297356,1002587,571457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]