SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517693 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517693 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944450,559043,433360,1043009,445488,671166,959888,791823,350091,898363,941444,197342,51171,890306,545005,762703,677911,23005,510708,258008,745718,101802,930483,866950,453254,421979,764254,340322,941979,231169,755491,350682,708927,724872,478039,469957,500549,376689,682152,605860,343138,26675,555314,452996,485370,345521,887615,555549,96712,59428,474552,73105,825090,346105,995209,14655,354285,230768,449721,602185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]