SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013247 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013247 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972145,162398,316951,737328,29757,248822,82326,275206,838389,774463,92594,296601,872411,933003,453468,186518,524862,721988,548343,61162,945805,25225,132575,395550,541757,579113,168410,69450,623063,710844,738358,652597,771273,381728,35249,320755,216864,503357,567684,818561,201804,914527,960517,188871,408479,925718,818417,1027953,456965,402071,8179,929434,188475,879709,725886,886436,1014498,679509,244221,49570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]