SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475449 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475449 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283710,179152,1025898,494416,819571,169707,803393,7444,390050,165026,501392,555909,436832,335670,656120,90393,953044,911609,150491,98669,131895,793534,110836,359356,523203,356792,139445,1019836,703215,1010416,291816,330624,221476,986303,98098,234662,329781,578076,712010,849030,1004328,121119,903269,566628,630307,251876,287460,740806,800982,709746,657887,252856,345777,620318,848959,705833,760319,929729,88853,244528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]