SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014072 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014072 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319791,245165,22025,714154,578143,1016112,10304,917631,476683,896811,925326,458648,441770,638772,1025582,1041041,341079,1008836,135154,462871,350558,447302,729440,965954,170076,352792,835256,451341,318413,867101,175120,918530,195167,962894,649038,736303,355735,12518,11578,200175,57526,144759,238941,394310,764197,308689,219837,769035,505133,438805,567429,899170,922834,1018861,1002363,223512,348961,693223,486256,520303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000821s ]