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` = 530713 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530713 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207065,129474,657147,1001091,624668,36888,570775,527555,43944,701233,1031802,97063,238463,813746,583849,953966,249902,5250,265231,274257,659831,673978,214163,889739,30270,769336,269922,531923,221480,254264,592497,739621,436398,829638,978480,444422,535298,878684,511487,371735,441986,36956,877702,49807,953080,23299,362236,768195,36125,806873,404804,190574,105083,207677,374858,589081,486115,1002288,686688,724524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001088s ]