SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001854s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014410 LIMIT 1 [ RunTime:0.001181s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014410 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291672,572692,396076,660395,599809,41678,776475,694607,785535,842131,773637,717694,403405,893913,948497,148950,302539,550657,733833,165329,381165,898811,399506,1046112,235116,886883,495167,311804,973787,965784,683834,982765,378147,680483,12883,430454,566538,789744,130993,1047521,309209,290570,50216,569273,702780,237882,1001291,122232,143014,465986,400867,825138,967115,225328,171450,188533,233795,1008126,57942,52280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]