SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505335 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505335 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920822,901301,515847,524072,896457,819338,792716,1029131,60998,1004243,953531,487239,126973,365014,112120,382824,333767,38468,731973,139612,211141,947673,209271,494528,856139,59257,897358,845161,755378,1167,13549,569662,985582,410900,200357,395517,202368,716534,969410,772757,57453,185369,41685,608032,957342,626951,591253,885106,577728,661746,647393,379761,175237,419086,703431,648820,652740,330364,489685,262747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]