SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514364 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514364 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189602,220344,224296,141045,1023124,328164,487107,786625,754189,178763,190852,876496,558491,939591,880609,286373,1016730,924817,989356,842987,448906,965911,416426,602878,800067,51014,517600,408543,1014001,218651,802774,561436,389817,462405,652102,762320,1047518,283733,924762,1022256,365863,303096,579056,507602,76926,235393,856247,316760,390121,463657,914217,572879,197530,836181,354265,601852,467769,795984,568305,901526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]